Application user privilege assignment should be reviewed monthly or more frequently to ensure compliance with least privilege and documented policy.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-3821	DG0080-ORACLE11	SV-24668r1_rule		Medium

Description
Users granted privileges not required to perform their assigned functions are able to make unauthorized modifications to the production data or database. Monthly or more frequent periodic review of privilege assignments assures that organizational and/or functional changes are reflected appropriately.

STIG	Date
Oracle Database 11g Instance STIG	2016-06-15

Details

Check Text ( C-1187r1_chk )
Review policy, procedures and implementation evidence to determine if periodic reviews of user privileges by the IAO are being performed. Evidence may consist of email or other correspondence that acknowledges receipt of periodic reports and notification of review between the DBA and IAO or other auditors as assigned. If policy and procedures are incomplete or no evidence of implementation exists, this is a Finding.

Check Text ( C-1187r1_chk )

Review policy, procedures and implementation evidence to determine if periodic reviews of user privileges by the IAO are being performed.

Evidence may consist of email or other correspondence that acknowledges receipt of periodic reports and notification of review between the DBA and IAO or other auditors as assigned.

If policy and procedures are incomplete or no evidence of implementation exists, this is a Finding.

Fix Text (F-2583r1_fix)
Develop, document and implement policy and procedures for periodic review of database user accounts and privilege assignments. Include methods to provide evidence of review in the procedures to verify reviews occur in accordance with the procedures.